WITH x AS (SELECT *, Row_number() OVER( partition BY employeeid ORDER BY ... Here's a complete version, tested just now on SQL Server 2016: ... <看更多>

Here is a full script that I used to reproduce it. Tried on Microsoft SQL Server 2014 - 12.0.2000.8 (X64) Feb 20 2014 20:04:26 Copyright (c) Microsoft ... ... <看更多>